Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	2166
Missing cells	402
Missing cells (%)	1.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	203.2 KiB
Average record size in memory	96.1 B

Variable types

Numeric	11
Categorical	1

Warnings

`Year` has constant value "0.0"	Constant
`df_index` is highly correlated with `ASGS_2016`	High correlation
`ASGS_2016` is highly correlated with `df_index`	High correlation
`Houses - median sale price ($)` is highly correlated with `RENT_2` and 1 other fields	High correlation
`HHTYPE_6` is highly correlated with `TENURE_3`	High correlation
`RENT_2` is highly correlated with `Houses - median sale price ($)` and 1 other fields	High correlation
`RENT_3` is highly correlated with `Houses - median sale price ($)` and 1 other fields	High correlation
`TENURE_2` is highly correlated with `TENURE_4`	High correlation
`TENURE_3` is highly correlated with `HHTYPE_6` and 1 other fields	High correlation
`TENURE_4` is highly correlated with `TENURE_2` and 1 other fields	High correlation
`MARRIAGE_2` is highly correlated with `MARRIAGE_4`	High correlation
`MARRIAGE_4` is highly correlated with `MARRIAGE_2`	High correlation
`df_index` is highly correlated with `ASGS_2016`	High correlation
`ASGS_2016` is highly correlated with `df_index`	High correlation
`Houses - median sale price ($)` is highly correlated with `RENT_2` and 1 other fields	High correlation
`HHTYPE_6` is highly correlated with `TENURE_3`	High correlation
`RENT_2` is highly correlated with `Houses - median sale price ($)` and 1 other fields	High correlation
`RENT_3` is highly correlated with `Houses - median sale price ($)` and 1 other fields	High correlation
`TENURE_2` is highly correlated with `TENURE_4`	High correlation
`TENURE_3` is highly correlated with `HHTYPE_6` and 1 other fields	High correlation
`TENURE_4` is highly correlated with `TENURE_2` and 1 other fields	High correlation
`MARRIAGE_2` is highly correlated with `MARRIAGE_4`	High correlation
`MARRIAGE_4` is highly correlated with `MARRIAGE_2`	High correlation
`df_index` is highly correlated with `ASGS_2016`	High correlation
`ASGS_2016` is highly correlated with `df_index`	High correlation
`Houses - median sale price ($)` is highly correlated with `RENT_2` and 1 other fields	High correlation
`HHTYPE_6` is highly correlated with `TENURE_3`	High correlation
`RENT_2` is highly correlated with `Houses - median sale price ($)` and 1 other fields	High correlation
`RENT_3` is highly correlated with `Houses - median sale price ($)` and 1 other fields	High correlation
`TENURE_3` is highly correlated with `HHTYPE_6`	High correlation
`MARRIAGE_2` is highly correlated with `MARRIAGE_4`	High correlation
`MARRIAGE_4` is highly correlated with `MARRIAGE_2`	High correlation
`TENURE_2` is highly correlated with `HHTYPE_6` and 3 other fields	High correlation
`HHTYPE_6` is highly correlated with `TENURE_2` and 4 other fields	High correlation
`MARRIAGE_2` is highly correlated with `ASGS_2016` and 2 other fields	High correlation
`ASGS_2016` is highly correlated with `MARRIAGE_2` and 3 other fields	High correlation
`MARRIAGE_4` is highly correlated with `MARRIAGE_2` and 2 other fields	High correlation
`RENT_3` is highly correlated with `TENURE_2` and 7 other fields	High correlation
`df_index` is highly correlated with `MARRIAGE_2` and 4 other fields	High correlation
`RENT_2` is highly correlated with `HHTYPE_6` and 5 other fields	High correlation
`TENURE_3` is highly correlated with `TENURE_2` and 4 other fields	High correlation
`TENURE_4` is highly correlated with `TENURE_2` and 4 other fields	High correlation
`Houses - median sale price ($)` is highly correlated with `RENT_3` and 1 other fields	High correlation
`Houses - median sale price ($)` has 375 (17.3%) missing values	Missing
`df_index` has unique values	Unique
`ASGS_2016` has unique values	Unique

Reproduction

Analysis started	2021-08-18 15:16:22.309394
Analysis finished	2021-08-18 15:16:44.238934
Duration	21.93 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	2166
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.574609941 × 10^-16

Minimum	-1.72035955
Maximum	1.792789285
Zeros	0
Zeros (%)	0.0%
Negative	1091
Negative (%)	50.4%
Memory size	17.0 KiB

Quantile statistics

Minimum	-1.72035955
5-th percentile	-1.551222144
Q1	-0.85933126
median	-0.01211010551
Q3	0.8535205625
95-th percentile	1.574176311
Maximum	1.792789285
Range	3.513148834
Interquartile range (IQR)	1.712851822

Descriptive statistics

Standard deviation	1.00023092
Coefficient of variation (CV)	6.352245685 × 10¹⁵
Kurtosis	-1.175878038
Mean	1.574609941 × 10^-16
Median Absolute Deviation (MAD)	0.8568094428
Skewness	0.02412642109
Sum	3.410605132 × 10^-13
Variance	1.000461894
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.8305663951	1	< 0.1%
-1.01466153	1	< 0.1%
-1.166540017	1	< 0.1%
0.39980276	1	< 0.1%
-0.6449371335	1	< 0.1%
-1.619107225	1	< 0.1%
-1.324555008	1	< 0.1%
-0.2153818175	1	< 0.1%
0.1359330659	1	< 0.1%
1.387779987	1	< 0.1%
Other values (2156)	2156	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.72035955	1	< 0.1%
-1.718825423	1	< 0.1%
-1.717291297	1	< 0.1%
-1.715757171	1	< 0.1%
-1.714223045	1	< 0.1%
-1.712688919	1	< 0.1%
-1.711154793	1	< 0.1%
-1.709620667	1	< 0.1%
-1.708086541	1	< 0.1%
-1.706552414	1	< 0.1%

Value	Count	Frequency (%)
1.792789285	1	< 0.1%
1.791255159	1	< 0.1%
1.789721032	1	< 0.1%
1.78665278	1	< 0.1%
1.775913897	1	< 0.1%
1.774379771	1	< 0.1%
1.772845645	1	< 0.1%
1.771311519	1	< 0.1%
1.769777393	1	< 0.1%
1.768243267	1	< 0.1%

ASGS_2016
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	2166
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.248699802 × 10^-17

Minimum	-1.117431002
Maximum	3.099693622
Zeros	0
Zeros (%)	0.0%
Negative	1356
Negative (%)	62.6%
Memory size	17.0 KiB

Quantile statistics

Minimum	-1.117431002
5-th percentile	-1.091126467
Q1	-0.9751546823
median	-0.0524354762
Q3	0.4850041707
95-th percentile	2.050697277
Maximum	3.099693622
Range	4.217124624
Interquartile range (IQR)	1.460158853

Descriptive statistics

Standard deviation	1.00023092
Coefficient of variation (CV)	1.905673706 × 10¹⁶
Kurtosis	0.2674733189
Mean	5.248699802 × 10^-17
Median Absolute Deviation (MAD)	0.5379142665
Skewness	0.9873775957
Sum	1.136868377 × 10^-13
Variance	1.000461894
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02645230005	1	< 0.1%
-1.091020973	1	< 0.1%
-1.001459236	1	< 0.1%
-1.022597752	1	< 0.1%
-1.091020999	1	< 0.1%
-0.9803207311	1	< 0.1%
-0.537476788	1	< 0.1%
2.572665711	1	< 0.1%
-0.5481252319	1	< 0.1%
-1.022492268	1	< 0.1%
Other values (2156)	2156	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.117431002	1	< 0.1%
-1.117430997	1	< 0.1%
-1.117430992	1	< 0.1%
-1.117430987	1	< 0.1%
-1.117430981	1	< 0.1%
-1.117430976	1	< 0.1%
-1.117378257	1	< 0.1%
-1.117378252	1	< 0.1%
-1.117378247	1	< 0.1%
-1.117378241	1	< 0.1%

Value	Count	Frequency (%)
3.099693622	1	< 0.1%
3.099640903	1	< 0.1%
3.099588185	1	< 0.1%
2.57298206	1	< 0.1%
2.572876475	1	< 0.1%
2.57287647	1	< 0.1%
2.572876465	1	< 0.1%
2.572876459	1	< 0.1%
2.572876454	1	< 0.1%
2.572876449	1	< 0.1%

Year
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	127.0 KiB

0.0	2166

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	6498
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	2166	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0.0	2166	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	4332	66.7%
.	2166	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4332	66.7%
Other Punctuation	2166	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4332	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	2166	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	6498	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4332	66.7%
.	2166	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6498	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4332	66.7%
.	2166	33.3%

Houses - median sale price ($)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	929
Distinct (%)	51.9%
Missing	375
Missing (%)	17.3%
Infinite	0
Infinite (%)	0.0%
Mean	-1.428226605 × 10^-16

Minimum	-1.366177591
Maximum	8.648440852
Zeros	0
Zeros (%)	0.0%
Negative	1151
Negative (%)	53.1%
Memory size	17.0 KiB

Quantile statistics

Minimum	-1.366177591
5-th percentile	-0.9635239339
Q1	-0.6040818885
median	-0.2505323357
Q3	0.2588409089
95-th percentile	1.930671989
Maximum	8.648440852
Range	10.01461844
Interquartile range (IQR)	0.8629227974

Descriptive statistics

Standard deviation	1.000279291
Coefficient of variation (CV)	-7.003645552 × 10¹⁵
Kurtosis	12.1696514
Mean	-1.428226605 × 10^-16
Median Absolute Deviation (MAD)	0.3980706076
Skewness	2.749068572
Sum	-2.557953849 × 10^-13
Variance	1.000558659
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.08468501804	16	0.7%
-0.570036376	15	0.7%
-0.4390920972	14	0.6%
-0.5176586645	14	0.6%
-0.3736199578	13	0.6%
-0.4914698087	13	0.6%
0.1370627296	12	0.6%
-0.6747917991	12	0.6%
-0.6224140875	12	0.6%
-0.2557701069	12	0.6%
Other values (919)	1658	76.5%
(Missing)	375	17.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.366177591	1	< 0.1%
-1.316418765	1	< 0.1%
-1.309871551	1	< 0.1%
-1.279754367	1	< 0.1%
-1.261422168	1	< 0.1%
-1.245708855	1	< 0.1%
-1.214936949	1	< 0.1%
-1.209044457	1	< 0.1%
-1.198568914	1	< 0.1%
-1.193985865	1	< 0.1%

Value	Count	Frequency (%)
8.648440852	1	< 0.1%
8.399646723	1	< 0.1%
7.496131199	1	< 0.1%
5.898610997	1	< 0.1%
5.374833882	1	< 0.1%
5.112945324	1	< 0.1%
4.89034005	1	< 0.1%
4.720112488	2	0.1%
4.59440598	1	< 0.1%
4.49096	1	< 0.1%

HHTYPE_6
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-4.52700358 × 10^-16

Minimum	-2.80625907
Maximum	7.542499185
Zeros	0
Zeros (%)	0.0%
Negative	1293
Negative (%)	59.7%
Memory size	17.0 KiB

Quantile statistics

Minimum	-2.80625907
5-th percentile	-1.407778225
Q1	-0.5686897177
median	-0.00929737958
Q3	0.5500949585
95-th percentile	1.668879635
Maximum	7.542499185
Range	10.34875825
Interquartile range (IQR)	1.118784676

Descriptive statistics

Standard deviation	1.00023092
Coefficient of variation (CV)	-2.20947676 × 10¹⁵
Kurtosis	5.150207831
Mean	-4.52700358 × 10^-16
Median Absolute Deviation (MAD)	0.5593923381
Skewness	1.180055613
Sum	-9.805489753 × 10^-13
Variance	1.000461894
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
-0.5686897177	291	13.4%
-0.2889935486	263	12.1%
-0.00929737958	234	10.8%
-0.8483858867	233	10.8%
0.2703987895	206	9.5%
0.5500949585	198	9.1%
0.8297911275	151	7.0%
-1.128082056	141	6.5%
1.109487297	112	5.2%
1.389183466	87	4.0%
Other values (21)	250	11.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2.80625907	2	0.1%
-2.526562901	2	0.1%
-2.246866732	13	0.6%
-1.967170563	21	1.0%
-1.687474394	29	1.3%
-1.407778225	64	3.0%
-1.128082056	141	6.5%
-0.8483858867	233	10.8%
-0.5686897177	291	13.4%
-0.2889935486	263	12.1%

Value	Count	Frequency (%)
7.542499185	2	0.1%
6.423714508	1	< 0.1%
6.144018339	1	< 0.1%
5.025233663	2	0.1%
4.465841325	1	< 0.1%
4.186145156	2	0.1%
3.906448987	2	0.1%
3.626752818	2	0.1%
3.347056649	2	0.1%
3.06736048	5	0.2%

RENT_2
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1133
Distinct (%)	52.4%
Missing	3
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.116895655 × 10^-16

Minimum	-2.62916074
Maximum	3.957546159
Zeros	0
Zeros (%)	0.0%
Negative	1081
Negative (%)	49.9%
Memory size	17.0 KiB

Quantile statistics

Minimum	-2.62916074
5-th percentile	-1.648284258
Q1	-0.6654064991
median	1.850465286 × 10^-5
Q3	0.670446704
95-th percentile	1.715864407
Maximum	3.957546159
Range	6.586706898
Interquartile range (IQR)	1.335853203

Descriptive statistics

Standard deviation	1.000231241
Coefficient of variation (CV)	8.955458249 × 10¹⁵
Kurtosis	-0.06423350917
Mean	1.116895655 × 10^-16
Median Absolute Deviation (MAD)	0.6679266015
Skewness	0.1155991035
Sum	2.415845302 × 10^-13
Variance	1.000462535
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.2551444667	7	0.3%
0.17262875	7	0.3%
0.5728843914	7	0.3%
0.3377342021	7	0.3%
0.4377981124	7	0.3%
0.9381176641	7	0.3%
-0.5728473821	6	0.3%
-0.417748321	6	0.3%
1.850465286 × 10^-5	6	0.3%
-0.004984690864	6	0.3%
Other values (1123)	2097	96.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2.62916074	1	< 0.1%
-2.596639969	1	< 0.1%
-2.571623991	1	< 0.1%
-2.551611209	1	< 0.1%
-2.541604818	1	< 0.1%
-2.499077656	1	< 0.1%
-2.41652493	1	< 0.1%
-2.411521735	1	< 0.1%
-2.381502562	1	< 0.1%
-2.333972204	1	< 0.1%

Value	Count	Frequency (%)
3.957546159	1	< 0.1%
3.137022094	1	< 0.1%
3.039459781	1	< 0.1%
3.02945339	1	< 0.1%
2.769287223	1	< 0.1%
2.719255268	1	< 0.1%
2.681731302	1	< 0.1%
2.676728106	1	< 0.1%
2.666721715	1	< 0.1%
2.624194553	1	< 0.1%

RENT_3
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1228
Distinct (%)	57.0%
Missing	13
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	-1.980146964 × 10^-16

Minimum	-3.849943279
Maximum	5.772769353
Zeros	0
Zeros (%)	0.0%
Negative	1110
Negative (%)	51.2%
Memory size	17.0 KiB

Quantile statistics

Minimum	-3.849943279
5-th percentile	-1.480986661
Q1	-0.7098343218
median	-0.03591060531
Q3	0.6108892464
95-th percentile	1.748005115
Maximum	5.772769353
Range	9.622712632
Interquartile range (IQR)	1.320723568

Descriptive statistics

Standard deviation	1.000232315
Coefficient of variation (CV)	-5.051303428 × 10¹⁵
Kurtosis	1.081703632
Mean	-1.980146964 × 10^-16
Median Absolute Deviation (MAD)	0.6593185585
Skewness	0.4631580527
Sum	-4.263256415 × 10^-13
Variance	1.000464684
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.2854028694	7	0.3%
0.2269822376	7	0.3%
-0.4406821254	7	0.3%
0.1685616059	7	0.3%
0.247846749	6	0.3%
0.124746132	6	0.3%
-0.728612382	6	0.3%
-0.7515633445	6	0.3%
0.5941976373	6	0.3%
-1.043666503	6	0.3%
Other values (1218)	2089	96.4%
(Missing)	13	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-3.849943279	1	< 0.1%
-3.224007939	1	< 0.1%
-2.808804163	1	< 0.1%
-2.754556434	1	< 0.1%
-2.368562974	1	< 0.1%
-2.339352658	1	< 0.1%
-2.268413319	2	0.1%
-2.262153966	1	< 0.1%
-2.184955274	1	< 0.1%
-2.145312702	1	< 0.1%

Value	Count	Frequency (%)
5.772769353	1	< 0.1%
5.382602991	1	< 0.1%
4.938188899	1	< 0.1%
4.487515454	1	< 0.1%
3.680058865	1	< 0.1%
3.442203436	1	< 0.1%
2.885120983	1	< 0.1%
2.874688727	1	< 0.1%
2.753674562	1	< 0.1%
2.745328757	1	< 0.1%

TENURE_2
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	459
Distinct (%)	21.2%
Missing	2
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.838742754 × 10^-16

Minimum	-3.115559563
Maximum	3.349415845
Zeros	0
Zeros (%)	0.0%
Negative	1008
Negative (%)	46.5%
Memory size	17.0 KiB

Quantile statistics

Minimum	-3.115559563
5-th percentile	-1.74834422
Q1	-0.6350402979
median	0.08763066917
Q3	0.7419408691
95-th percentile	1.445080188
Maximum	3.349415845
Range	6.464975408
Interquartile range (IQR)	1.376981167

Descriptive statistics

Standard deviation	1.000231134
Coefficient of variation (CV)	5.439755678 × 10¹⁵
Kurtosis	-0.1834578494
Mean	1.838742754 × 10^-16
Median Absolute Deviation (MAD)	0.6933734954
Skewness	-0.3732769706
Sum	3.97903932 × 10^-13
Variance	1.000462321
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.185288908	15	0.7%
0.5661560393	14	0.6%
-0.1467491039	13	0.6%
0.5759218631	13	0.6%
0.7907699885	13	0.6%
-0.1272174562	13	0.6%
0.08763066917	13	0.6%
0.6345168064	12	0.6%
0.009504078138	12	0.6%
0.06809902141	12	0.6%
Other values (449)	2034	93.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-3.115559563	1	< 0.1%
-3.05696462	1	< 0.1%
-3.037432972	1	< 0.1%
-2.998369677	1	< 0.1%
-2.959306381	1	< 0.1%
-2.93000891	1	< 0.1%
-2.900711438	1	< 0.1%
-2.861648142	1	< 0.1%
-2.822584847	1	< 0.1%
-2.793287375	1	< 0.1%

Value	Count	Frequency (%)
3.349415845	1	< 0.1%
2.460725872	1	< 0.1%
2.30447269	1	< 0.1%
2.294706866	1	< 0.1%
2.275175218	1	< 0.1%
2.236111923	1	< 0.1%
2.226346099	1	< 0.1%
2.216580275	1	< 0.1%
2.148219508	1	< 0.1%
2.138453684	2	0.1%

TENURE_3
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	493
Distinct (%)	22.8%
Missing	7
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	4.681551837 × 10^-16

Minimum	-3.130457308
Maximum	3.876674718
Zeros	0
Zeros (%)	0.0%
Negative	1225
Negative (%)	56.6%
Memory size	17.0 KiB

Quantile statistics

Minimum	-3.130457308
5-th percentile	-1.351723794
Q1	-0.6644858449
median	-0.1479344455
Q3	0.5887127675
95-th percentile	1.820350974
Maximum	3.876674718
Range	7.007132026
Interquartile range (IQR)	1.253198612

Descriptive statistics

Standard deviation	1.000231669
Coefficient of variation (CV)	2.136538703 × 10¹⁵
Kurtosis	0.7555211844
Mean	4.681551837 × 10^-16
Median Absolute Deviation (MAD)	0.6018946741
Skewness	0.467471108
Sum	1.010747042 × 10^-12
Variance	1.000463392
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.3276044975	17	0.8%
-0.4443900312	16	0.7%
-0.606093078	15	0.7%
-0.3904890157	15	0.7%
-0.6869446014	14	0.6%
-0.4803240416	14	0.6%
-0.2737034819	14	0.6%
-0.01318190654	14	0.6%
-0.8666146533	14	0.6%
-0.04911591694	13	0.6%
Other values (483)	2013	92.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-3.130457308	1	< 0.1%
-3.112490303	1	< 0.1%
-3.094523298	1	< 0.1%
-3.085539795	1	< 0.1%
-3.076556292	2	0.1%
-3.049605785	1	< 0.1%
-3.040622282	1	< 0.1%
-3.013671774	1	< 0.1%
-2.995704769	1	< 0.1%
-2.968754261	1	< 0.1%

Value	Count	Frequency (%)
3.876674718	1	< 0.1%
3.732938677	1	< 0.1%
3.463433599	1	< 0.1%
3.454450096	1	< 0.1%
3.391565578	1	< 0.1%
3.382582075	1	< 0.1%
3.373598573	1	< 0.1%
3.184945018	1	< 0.1%
3.068159485	1	< 0.1%
3.059175982	2	0.1%

TENURE_4
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	542
Distinct (%)	25.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-1.312781036 × 10^-16

Minimum	-1.773699529
Maximum	4.8835397
Zeros	0
Zeros (%)	0.0%
Negative	1254
Negative (%)	57.9%
Memory size	17.0 KiB

Quantile statistics

Minimum	-1.773699529
5-th percentile	-1.273318802
Q1	-0.6786634465
median	-0.1710308256
Q3	0.4671358978
95-th percentile	1.903011025
Maximum	4.8835397
Range	6.657239228
Interquartile range (IQR)	1.145799344

Descriptive statistics

Standard deviation	1.000231027
Coefficient of variation (CV)	-7.619176386 × 10¹⁵
Kurtosis	2.813739628
Mean	-1.312781036 × 10^-16
Median Absolute Deviation (MAD)	0.558395883
Skewness	1.324677877
Sum	-2.842170943 × 10^-13
Variance	1.000462107
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.7439304978	14	0.6%
-0.07675619603	14	0.6%
-0.3668319794	13	0.6%
-0.3015649281	13	0.6%
-0.5263736602	12	0.6%
-0.6786634465	12	0.6%
0.1262968523	12	0.6%
-0.09851187978	12	0.6%
0.1480525361	12	0.6%
-0.3378244011	12	0.6%
Other values (532)	2039	94.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.773699529	2	0.1%
-1.730188161	1	< 0.1%
-1.701180583	1	< 0.1%
-1.686676794	1	< 0.1%
-1.672173005	1	< 0.1%
-1.635913532	1	< 0.1%
-1.628661637	3	0.1%
-1.614157848	1	< 0.1%
-1.599654059	1	< 0.1%
-1.577898375	1	< 0.1%

Value	Count	Frequency (%)
4.8835397	1	< 0.1%
4.796516965	1	< 0.1%
4.723998019	1	< 0.1%
4.687738546	1	< 0.1%
4.680486651	1	< 0.1%
4.644227178	1	< 0.1%
4.593463916	2	0.1%
4.549952549	1	< 0.1%
4.470181708	1	< 0.1%
4.310640027	1	< 0.1%

MARRIAGE_2
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1860
Distinct (%)	85.9%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0

Minimum	-1.611554573
Maximum	3.547444515
Zeros	0
Zeros (%)	0.0%
Negative	1259
Negative (%)	58.1%
Memory size	17.0 KiB

Quantile statistics

Minimum	-1.611554573
5-th percentile	-1.236112456
Q1	-0.8054609654
median	-0.2175408414
Q3	0.6179487723
95-th percentile	1.949863441
Maximum	3.547444515
Range	5.158999088
Interquartile range (IQR)	1.423409738

Descriptive statistics

Standard deviation	1.000231027
Coefficient of variation (CV)	nan
Kurtosis	0.0328850444
Mean	0
Median Absolute Deviation (MAD)	0.666462578
Skewness	0.8120292814
Sum	0
Variance	1.000462107
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.6768534383	4	0.2%
-0.9657610617	4	0.2%
-0.8196996559	4	0.2%
0.8999667068	4	0.2%
-0.1863075848	3	0.1%
-0.7494248286	3	0.1%
-0.5032332766	3	0.1%
-1.012151634	3	0.1%
-1.085641649	3	0.1%
-1.306571009	3	0.1%
Other values (1850)	2131	98.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.611554573	1	< 0.1%
-1.606961447	1	< 0.1%
-1.606502134	1	< 0.1%
-1.603286946	1	< 0.1%
-1.602827634	1	< 0.1%
-1.596397257	2	0.1%
-1.593182069	1	< 0.1%
-1.590426193	1	< 0.1%
-1.57572819	1	< 0.1%
-1.567460564	1	< 0.1%

Value	Count	Frequency (%)
3.547444515	1	< 0.1%
3.477169688	1	< 0.1%
3.333864158	1	< 0.1%
3.178157187	1	< 0.1%
3.16621506	1	< 0.1%
3.143708742	1	< 0.1%
3.124417613	1	< 0.1%
3.08307948	1	< 0.1%
3.058276599	1	< 0.1%
3.029799218	1	< 0.1%

MARRIAGE_4
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1802
Distinct (%)	83.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.624349901 × 10^-17

Minimum	-1.52034968
Maximum	4.082065696
Zeros	0
Zeros (%)	0.0%
Negative	1274
Negative (%)	58.8%
Memory size	17.0 KiB

Quantile statistics

Minimum	-1.52034968
5-th percentile	-1.161250202
Q1	-0.8022794794
median	-0.2608620162
Q3	0.6615433835
95-th percentile	1.900043878
Maximum	4.082065696
Range	5.602415376
Interquartile range (IQR)	1.463822863

Descriptive statistics

Standard deviation	1.00023092
Coefficient of variation (CV)	3.811347411 × 10¹⁶
Kurtosis	0.213944171
Mean	2.624349901 × 10^-17
Median Absolute Deviation (MAD)	0.6669542114
Skewness	0.8851476318
Sum	5.684341886 × 10^-14
Variance	1.000461894
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1.094941047	6	0.3%
-1.05322422	5	0.2%
-1.048589017	4	0.2%
0.01287247284	4	0.2%
-0.8606057839	4	0.2%
0.2642034807	4	0.2%
-0.4346821293	4	0.2%
-0.5706480843	4	0.2%
-0.4903045654	3	0.1%
-0.857000626	3	0.1%
Other values (1792)	2125	98.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1.52034968	1	< 0.1%
-1.514169409	1	< 0.1%
-1.509534206	1	< 0.1%
-1.509019183	1	< 0.1%
-1.507989138	1	< 0.1%
-1.506959093	1	< 0.1%
-1.499233755	1	< 0.1%
-1.489448326	1	< 0.1%
-1.487903258	1	< 0.1%
-1.487388236	1	< 0.1%

Value	Count	Frequency (%)
4.082065696	1	< 0.1%
3.900777756	1	< 0.1%
3.793653064	1	< 0.1%
3.46043347	1	< 0.1%
3.431077184	1	< 0.1%
3.392450492	1	< 0.1%
3.388330312	1	< 0.1%
3.348158552	1	< 0.1%
3.255454492	1	< 0.1%
3.129273966	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	ASGS_2016	Houses - median sale price ($)	HHTYPE_6	RENT_2	RENT_3	TENURE_2	TENURE_3	TENURE_4	MARRIAGE_2	MARRIAGE_4
0	-1.720360	-1.117431	-0.543848	-0.848386	-1.028138	-0.503276	1.406017	-0.408456	-0.685915	-1.056246	-1.094426
1	-1.718825	-1.117431	NaN	0.270399	0.005022	0.162302	-0.410426	0.301241	0.061030	-0.273577	-0.135969
2	-1.717291	-1.117431	NaN	-1.407778	0.052552	-0.133974	-0.693635	-0.309637	0.699197	-0.311241	0.397594
3	-1.715757	-1.117431	NaN	-1.128082	0.015028	0.364688	-0.928015	-0.255736	0.982020	-0.974029	-0.695284
4	-1.714223	-1.117431	0.281101	0.829791	0.317721	1.063649	0.224352	1.487063	-1.266067	1.049243	-0.027814
5	-1.712689	-1.117431	NaN	1.109487	0.778015	1.188836	-0.869420	1.352310	-0.301565	0.696951	-0.009789
6	-1.711155	-1.117378	NaN	-1.128082	-1.881183	-1.794789	1.747821	-0.920516	-0.577137	-1.206900	-1.180950
7	-1.709621	-1.117378	NaN	-0.848386	-0.920569	-1.089568	0.448966	-0.417440	-0.004237	-0.591881	-0.516571
8	-1.708087	-1.117378	NaN	-0.568690	-1.083173	-0.784947	1.650162	-0.120984	-1.092021	-1.013070	-1.143868
9	-1.706552	-1.117378	NaN	-0.288994	0.737990	-0.350965	0.253650	-0.192852	-0.178283	-0.758152	-0.775112

Last rows

	df_index	ASGS_2016	Houses - median sale price ($)	HHTYPE_6	RENT_2	RENT_3	TENURE_2	TENURE_3	TENURE_4	MARRIAGE_2	MARRIAGE_4
2156	1.768243	2.572876	0.182893	-1.128082	0.235169	0.594198	-0.361597	-1.073235	1.170570	-1.221139	-1.002237
2157	1.769777	2.572876	0.359668	-1.128082	0.612910	0.667223	-0.058857	-0.686945	0.684693	-1.145812	-0.977001
2158	1.771312	2.572876	2.003019	1.668880	2.544143	3.680059	2.236112	-0.085050	-1.505379	-1.409916	-1.418890
2159	1.772846	2.572876	0.372762	-0.568690	0.752999	0.955154	0.751707	-0.489308	-0.076756	-1.181638	-1.115542
2160	1.774380	2.572876	NaN	-2.246867	0.885584	0.333391	-1.445604	-1.154087	2.135072	-1.371334	-1.051679
2161	1.775914	2.572876	0.186822	-0.009297	0.697964	0.702693	0.507561	-0.103017	-0.185535	-1.208737	-1.203096
2162	1.786653	2.572982	NaN	0.550095	-0.853026	2.451139	-1.523730	-0.552192	1.438890	-1.553222	-1.471423
2163	1.789721	3.099588	NaN	-0.009297	-1.260787	-0.350965	0.009504	-2.070404	1.482401	-1.382358	-1.352967
2164	1.791255	3.099641	NaN	3.347057	-1.545969	NaN	-2.197572	-2.968754	2.584689	-1.479732	-1.487903
2165	1.792789	3.099694	NaN	1.389183	-1.440902	NaN	-2.822585	NaN	4.883540	-1.596397	-1.464727

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows